from sqlite_function import *

# table1 = ['轴承', '油管', '铜阀', '螺丝-平键-天车配件', '快叉-刀头', '角带-链条', '机械加工', '焊接', '电器', '电工附件', '磁棒-锯片']

# con, cur = db_open()

# for i in table1:
#     sql = f'''
#         delete from '{i}' where date >= '2021-12-05'
#     '''
#     cur.execute(sql)
#     con.commit()

# print('全部完成')
    
con, cur = db_open()

temp1 = sqliteObject_to_list_h(cur, f'''
    select * from '轴承' where smallname = '大声的'
''')
print(temp1 == [[]])